Diagram Pharmacy P4 ZSMOPL

Defincja diagramu Pharmacy P4 ZSMOPL

Name

Pharmacy P4 ZSMOPL

Code

Pharmacy_P4_ZSMOPL

Comment

 


Lista tabel diagramu

Name

Code

PhP4Communication

PhP4Communication

PhP4CommunicationStatus

PhP4CommunicationStatus

PhP4CommunicationStatusText

PhP4CommunicationStatusText

PhP4CommunicationType

PhP4CommunicationType

PhP4CommunicationTypeText

PhP4CommunicationTypeText

PhP4ExternalStatus

PhP4ExternalStatus

PhP4ExternalStatusText

PhP4ExternalStatusText

PhP4TimeTable

PhP4TimeTable

PhP4TimeTableItem

PhP4TimeTableItem

PhP4TimeTableItemStatus

PhP4TimeTableItemStatus

PhP4TimeTableItemStatusText

PhP4TimeTableItemStatusText

PhP4TimeTableStatus

PhP4TimeTableStatus

PhP4TimeTableStatusText

PhP4TimeTableStatusText

PhP4TimeTableType

PhP4TimeTableType

PhP4TimeTableTypeText

PhP4TimeTableTypeText

PhP4Transaction

PhP4Transaction

PhP4TransactionCriteria

PhP4TransactionCriteria

PhP4TransactionLot

PhP4TransactionLot


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_2503

R_2503

PhP4CommunicationType

PhP4CommunicationTypeText

CommunicationTypeID

 

 

R_2504

R_2504

PhP4CommunicationType

PhP4Transaction

TypeID

 

 

R_2509

R_2509

PhP4ExternalStatus

PhP4ExternalStatusText

ExternalStatusID

 

 

R_2510

R_2510

PhP4ExternalStatus

PhP4Transaction

ExternalStatusID

 

 

R_2511

R_2511

PhP4Transaction

PhP4TransactionLot

TransactionID

 

 

R_10263

R_10263

PhP4CommunicationStatus

PhP4CommunicationStatusText

CommunicationStatusID

 

 

R_10264

R_10264

PhP4TransactionCriteria

PhP4Transaction

TransactionCriteriaID

 

 

R_10265

R_10265

PhP4CommunicationStatus

PhP4Transaction

StatusID

 

 

R_10266

R_10266

PhP4CommunicationStatus

PhP4Communication

StatusID

 

 

R_10267

R_10267

PhP4Transaction

PhP4Communication

TransactionID

 

 

R_10473

R_10473

PhP4TimeTableStatus

PhP4TimeTableStatusText

TimeTableStatusID

 

 

R_10474

R_10474

PhP4TimeTableType

PhP4TimeTableTypeText

TimeTableTypeID

 

 

R_10475

R_10475

PhP4TimeTableItemStatus

PhP4TimeTableItemStatusText

TimeTableItemStatusID

 

 

R_10476

R_10476

PhP4TimeTableStatus

PhP4TimeTable

TimeTableStatusID

 

 

R_10477

R_10477

PhP4TimeTableType

PhP4TimeTable

TimeTableTypeID

 

 

R_10478

R_10478

PhP4TransactionCriteria

PhP4TimeTableItem

TransactionCriteriaID

 

 

R_10479

R_10479

PhP4TimeTable

PhP4TimeTableItem

TimeTableID

 

 

R_10480

R_10480

PhP4TimeTableItemStatus

PhP4TimeTableItem

TimeTableItemStatusID

 

 

R_10481

R_10481

PhP4TimeTableItem

PhP4Transaction

TimeTableItemID